/*
Navicat SQL Server Data Transfer

Source Server         : Balder@UCN
Source Server Version : 105000
Source Host           : Balder.ucn.dk:1433
Source Database       : dmaa0912_E7
Source Schema         : dbo

Target Server Type    : SQL Server
Target Server Version : 105000
File Encoding         : 65001

Date: 2013-10-09 13:58:16
*/


-- ----------------------------
-- Table structure for Seat
-- ----------------------------
DROP TABLE [dbo].[Seat]
GO
CREATE TABLE [dbo].[Seat] (
[Id] int NOT NULL IDENTITY(1,1),
[Number] int NOT NULL ,
[Type] varchar(20) NOT NULL ,
[RowID] int NOT NULL 
)


GO

-- ----------------------------
-- Indexes structure for table Seat
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table Seat
-- ----------------------------
ALTER TABLE [dbo].[Seat] ADD PRIMARY KEY ([Id])
GO

-- ----------------------------
-- Foreign Key structure for table [dbo].[Seat]
-- ----------------------------
ALTER TABLE [dbo].[Seat] ADD FOREIGN KEY ([RowID]) REFERENCES [dbo].[Row] ([Id]) ON DELETE NO ACTION ON UPDATE NO ACTION
GO
